﻿using System;
using System.Collections.Generic;
using System.Text;

namespace Coldairarrow.Util.PageSql
{
   public class SqlPage
    {
        public static string GetPageResut( string str, int Page, int PageNum)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append(str);
            builder.Append($" OFFSET ({PageNum} * ({Page}-1)) ROWS FETCH NEXT {PageNum} ROWS ONLY");

            return builder.ToString();
        }
    }
}
